//Figure 5: Team Accountability
//Author  : Sriram Rajagopalan

//Tasks
Table Tasks {
  Task_Id integer [pk]
  Project_Id integer
  Requirement_Id integer
  Release_Id integer
  Task_Priority_Id integer
  Task_Type_Id integer
  Task_Folder_Id integer
  Project_Group_Id integer
  Risk_Id integer
  Component_Id integer
  Note:'Stores Task information related to one or more artifacts'
}

Table TaskPriorities {
  Task_Priority_Id integer [pk]
  Project_Template_Id integer
  Note: 'Template: Contains information on Task Priority '
}

Table TaskTypes {
  Task_Type_Id integer [pk]
  Project_Template_Id integer
  Task_Workflow_Id integer
  Note: 'Template: Contains information on Task Types and association with Workflow'
}

//Risks
Table Risks {
  Risk_Id integer [pk]
  Risk_Impact_Id integer
  Risk_Status_Id integer
  Risk_Probability_Id integer
  Risk_Type_Id integer
  Project_Id integer
  Project_Group_Id integer
  Release_Id integer
  Component_Id integer
  Note: 'Stores product level risk information'
}

Table RiskImpacts {
  Risk_Impact_Id integer [pk]
  Project_Template_Id integer
  Note: 'Template: Contains Risk Impact Scores'
}

Table RiskMitigations {
  Risk_Mitigation_Id integer [pk]
  Risk_Id integer
  Note: 'Stores mitigations for a specific product level risk'
}

Table RiskProbabilities {
  Risk_Probability_Id integer [pk]
  Project_Template_Id integer
  Note: 'Template: Contains Risk Probability Scores'
}

Table RiskStatuses {
  Risk_Status_Id integer [pk]
  Project_Template_Id integer
  Note: 'Template: Contains Risk Status Details'
}

Table RiskTypes {
  Risk_Type_Id integer [pk]
  Project_Template_Id integer
  Note: 'Template: Contains Risk Type Details'
}


//Minimal Relationships
//Tasks
Ref: TaskPriorities.Task_Priority_Id - Tasks.Task_Priority_Id
Ref: TaskTypes.Task_Type_Id - Tasks.Task_Type_Id 

//Risks
Ref: RiskImpacts.Risk_Impact_Id - Risks.Risk_Impact_Id 
Ref: RiskMitigations.Risk_Id - Risks.Risk_Id 
Ref: Risks.Risk_Probability_Id - RiskProbabilities.Risk_Probability_Id 
Ref: Risks.Risk_Status_Id - RiskStatuses.Risk_Status_Id 
Ref: Risks.Risk_Type_Id - RiskTypes.Risk_Type_Id